package com.mk.cloud.common.domain;
import org.beetl.sql.core.annotatoin.AssignID;
import org.beetl.sql.core.annotatoin.Param;
import org.beetl.sql.core.annotatoin.SqlStatement;
import org.beetl.sql.core.annotatoin.SqlStatementType;
import org.beetl.sql.core.mapper.BaseMapper;

import java.io.Serializable;
import java.math.*;
import java.util.Date;
import java.sql.Timestamp;
import java.util.List;

/*
* 
* gen by beetlsql 2018-04-04
*/
public class PSchemeCode   implements Serializable{
	//方案关联编码
	@AssignID
	private String pscode ;
	//是否已使用
	private String isused ;
	//方案主键
	private String sid ;
	private String coid;

	public String getCoid() {
		return coid;
	}

	public void setCoid(String coid) {
		this.coid = coid;
	}
	
	public PSchemeCode() {
	}
	
	public String getPscode(){
		return  pscode;
	}
	public void setPscode(String pscode ){
		this.pscode = pscode;
	}
	
	public String getIsused(){
		return  isused;
	}
	public void setIsused(String isused ){
		this.isused = isused;
	}
	
	public String getSid(){
		return  sid;
	}
	public void setSid(String sid ){
		this.sid = sid;
	}

	public interface Mapper extends BaseMapper<PSchemeCode> {

		/**
		 * sid相关的编码
		 * @param sid
		 * @return
		 */
		List<String> selectPscodesBySid(@Param("sid") String sid);

		/**
		 * 批量插入编码
		 * @param pSchemeCodesList
		 * @return
		 */
		@SqlStatement(type= SqlStatementType.INSERT)
		void insertPSchemeCodesList(@Param("pSchemeCodesList") List<PSchemeCode> pSchemeCodesList);
	}
	

}
